graphic2
graphic1

Exam 77-420 Microsoft Excel 2013
4. Apply Formulas and Functions
4.4 Format and Modify Text with Functions: Use the RIGHT, LEFT and MID Functions

no

TEXT: LEFT

When the LEFT Function opens, please edit the Function Arguments.

Text
is the Cell that has the string of characters. In this case it is the Cells in Column A that have names of the months.

Num_chars indicates how many characters should be extracted from the left of the string.

 

3. Try it: Edit the LEFT Function Arguments
Text: Select Cell A2.
Num_chars: 3.
There will be a preview of the results: Jan.
Click OK.

 

Do This, Too: Copy the LEFT Function
Select Cell J2 (The Cell with the LEFT Function.)
Copy Cell J2 and paste the LEFT Function into Cells J3:J69

Keep going...

Formulas ->Function Library-> Text->LEFT